| Purpose |
Need to create a new VAS condition table and update it in UPC label program for material and Purchase order inputs.Add the new table in ZRSD_VAS_UPDATE program. |
| Release No |
001 |
| Submitted on |
04/23/2015 |
| Submitted by |
Deepak Yasam |
| Environment |
NECNED to NECNEQ |
| Sent To |
Daniel Brennan |
| Object(s) created by |
Damodhier/Deepak Yasam |
| Object(s) tested by |
Deepak Yasam |
| Transport Status |
Created in NECNED100 |
| Sl. |
Transport ID |
Description |
Object Name |
| 1 |
NEDK929695 |
SD:17194:VAS Cond.tab Sorg/D.C/Div/Plant and assign to ZAST |
KOTK922 V_T682 |
| 2 |
NEDK929701 |
SD:17194: Prgm chgs to update ZSDVAS table with KOTK922 tabl |
ZRSD_VAS_UPDATE |
| 3 |
NEDK929719 |
SD:17194:Changes to include KOTK922 table for Mat&Pur.Ord In |
ZRSD_UPC_LABELS |
| Test ID |
Scenario |
Expected Result |
Actual Result |
P/F |
Test Documents |
Notes |
Tested By |
QA By |
| SD-001 |
For Stock items: Execute ZSD_UPCLBL t.code with the below inputs. Material,size,qty,S.org,cur,MSRP |
The condition record should be fetched from the below tables in a series. KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr KOTK906 Sales org./Distr. Chl/Division/Customer KOTK907 Sales org./Distr. Chl/Division/VAS Cu.Gr/Material KOTK908 Sales org./Distr. Chl/Division/Customer/Material KOTK903 Sales org./Distr. Chl/Division/Customer/Usage/VAS Mat.gr KOTK909 Sales org./Distr. Chl/Division/Customer/Usage KOTK902 Sales org./PO type KOTK922 Sales org./Distr. Chl/Division/Plant The condition record from 922 table should be used to print the labels as no other condition record is maintained ie., L98,S11 with delivering plant 0610 in the MM. |
The condition record from 922 table is used to print the labels as no other condition record is maintained ie., L98,S11 with delivering plant 0610 in the MM. |
P |
Material – 10017599 Size – 612 qty – 5 S.org – 3200 Cur – USD MSRP – blank |
NA |
Deepak yasam |
Deepak yasam |
| SD-002 |
For Stock items: Execute ZSD_UPCLBL t.code with the below inputs. Material,size,qty,S.org,cur,MSRP |
The condition record should be fetched from the below tables in series. KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr KOTK906 Sales org./Distr. Chl/Division/Customer KOTK907 Sales org./Distr. Chl/Division/VAS Cu.Gr/Material KOTK908 Sales org./Distr. Chl/Division/Customer/Material KOTK903 Sales org./Distr. Chl/Division/Customer/Usage/VAS Mat.gr KOTK909 Sales org./Distr. Chl/Division/Customer/Usage KOTK902 Sales org./PO type KOTK922 Sales org./Distr. Chl/Division/Plant As no condition record is maintained/deleted in any of the above tables and the condition record in KOTK922 with plant 0610(delivering plant in the MM) is deleted, no label should get printed. |
The condition record is fetched from the below tables in series. KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr KOTK906 Sales org./Distr. Chl/Division/Customer KOTK907 Sales org./Distr. Chl/Division/VAS Cu.Gr/Material KOTK908 Sales org./Distr. Chl/Division/Customer/Material KOTK903 Sales org./Distr. Chl/Division/Customer/Usage/VAS Mat.gr KOTK909 Sales org./Distr. Chl/Division/Customer/Usage KOTK902 Sales org./PO type KOTK922 Sales org./Distr. Chl/Division/Plant As no condition record is maintained/deleted in any of the above tables and the condition record in KOTK922 with plant 0610(delivering plant in the MM) is deleted, no label should get printed. |
P |
Material – 10017600 Size – 612 qty – 5 S.org – 3200 Cur – JPY MSRP – blank |
NA |
Deepak yasam |
Deepak yasam |
| SD-003 |
For Stock Items: Below are the inputs for prepack materials : Execute ZSD_UPCLBL transaction with the inputs Material number,size,qty,sales org,currency,MSRP with print components button flagged |
Only the input material, size,quantity and their respective components should get printed. As no condition records are maintained/deleted in the series of tables, the VAS codes ie.,L12 ,S20 from KOTK922 table with 0320 plant(delivering plant in MM) are used to print the labels. |
As no condition records are maintained/deleted in the series of tables, the VAS codes ie.,L12 ,S20 from KOTK922 table with 0320 plant(delivering plant in MM) are used to print the labels. |
P |
Material – 10017002 Size – U qty – 5 sales org – 2000 currency – EUR MSRP – input any value. |
NA |
Deepak yasam |
Deepak yasam |
| SD-004 |
For Stock Items: Below are the inputs for prepack materials : Material number,size,qty,sales org,currency,MSRP with print components button unflagged |
The input material, size,quantity should get printed . As no condition records are maintained/deleted in the series of tables, the VAS codes ie.,L12 ,S20 from KOTK922 table with 0320 plant(delivering plant in MM) are used to print the labels. |
The input material, size,quantity is printed . As no condition records are maintained/deleted in the series of tables, the VAS codes ie.,L12 ,S20 from KOTK922 table with 0320 plant(delivering plant in MM) are used to print the labels. |
P |
Material – 10017002 Size – U qty – 5 sales org – 2000 currency – EUR MSRP – blank |
NA |
Deepak yasam |
Deepak yasam |
| SD-005 |
For Stock Items: Below are the inputs for prepack materials : Material number,size,qty,sales org,currency,MSRP with print components button flagged |
As no condition record is maintained/deleted in any of the above series tables and the condition record in KOTK922 with plant 0315 (delivering plant in the MM) is deleted, no label should get printed. |
As no condition record is maintained/deleted in any of the above series tables and the condition record in KOTK922 with plant 0315 (delivering plant in the MM) is deleted, no label should get printed. |
P |
Material – 10017004 Size – G qty – 5 sales org – 2000 currency – EUR MSRP – blank |
NA |
Deepak yasam |
Deepak yasam |
| SD-006 |
For Stock Items: Below are the inputs for prepack materials : Material number,size,qty,sales org,currency,MSRP with print components button unflagged |
As no condition record is maintained/deleted in any of the above series tables and the condition record in KOTK922 with plant 0315 (delivering plant in the MM) is deleted, no label should get printed.. |
As no condition record is maintained/deleted in any of the above series tables and the condition record in KOTK922 with plant 0315 (delivering plant in the MM) is deleted, no label is printed.. |
P |
Material – 10017004 Size – G qty – 5 sales org – 2000 currency – EUR MSRP –blank |
NA |
Deepak yasam |
Deepak yasam |
| SD-007 |
For Stock items: Create a Purchase order and execute in ZSD_UPCLBL T.code under UPC(stock items only) |
The condition record should be fetched from below tables ie., KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr KOTK922 Sales org./Distr. Chl/Division/Plant The valid condition record is found in KOTK922 table with plant 0610 and 3200 sales org. Both item 10 and 20 are printed as they have record with 0610 plant in the PO. |
The valid condition record is found in KOTK922 table with plant 0610 and 3200 sales org. Both item 10 and 20 are printed as they have record with 0610 plant in the PO. |
P |
PO - 4600007926 |
NA |
Deepak yasam |
Deepak yasam |
| SD-008 |
For Stock items: Create a Purchase order and execute in ZSD_UPCLBL T.code under UPC(stock items only) |
The condition record should be fetched from below tables ie., KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr KOTK922 Sales org./Distr. Chl/Division/Plant The valid condition record is found in KOTK922 table with plant 0610 and 3200 sales org and item 10 is printed. Item 20 is not printed as the condition record with plant 0620 and sales org 3200 is deleted in KOTK922 table. |
The valid condition record is found in KOTK922 table with plant 0610 and 3200 sales org and item 10 is printed. Item 20 is not printed as the condition record with plant 0620 and sales org 3200 is deleted in KOTK922 table. |
P |
PO - 4600007929 |
NA |
Deepak yasam |
Deepak yasam |
| SD-009 |
For Stock items: Create a Purchase order and execute in ZSD_UPCLBL T.code under UPC(stock items only) |
The condition record should be fetched from below tables ie., KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr KOTK922 Sales org./Distr. Chl/Division/Plant The valid condition record is found in KOTK922 table with plant 0610 and 3200 sales org. Only item 20 is printed as item 20 is deleted in the PO. |
The valid condition record is found in KOTK922 table with plant 0610 and 3200 sales org. Only item 20 is printed as item 20 is deleted in the PO. |
P |
PO – 4600007932 |
NA |
Deepak yasam |
Deepak yasam |
| SD-010 |
For Stock items: Create a Purchase order with some deleted pre pack materials and execute in ZSD_UPCLBL T.code under UPC(stock items only) with print components flagged. |
The condition record should be fetched from 901 table ie., KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr KOTK922 Sales org./Distr. Chl/Division/Plant Valid condition record is found in KOTK922 table with plant 0320 and sales org 2000. Only the undeleted material sizes and their respective components should get printed in the output |
Valid condition record is found in KOTK922 table with plant 0320 and sales org 2000. Only the undeleted material sizes and their respective components are printed in the output |
P |
PO - 4600005480 |
NA |
Deepak yasam |
Deepak yasam |
| SD-011 |
For Stock items: Create a Purchase order with some deleted pre pack materials and execute in ZSD_UPCLBL T.code under UPC(stock items only) with print components unflagged |
The condition record should be fetched from 901 table ie., KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr KOTK922 Sales org./Distr. Chl/Division/Plant Valid condition record is found in KOTK922 table with plant 0320 and sales org 2000. Only the undeleted main material sizes of the purchase order should get printed. |
Valid condition record is found in KOTK922 table with plant 0320 and sales org 2000. Only the undeleted main material sizes of the purchase order should get printed. |
P |
PO – 4600005480 |
NA |
Deepak yasam |
Deepak yasam |